pp108 : Configuring Audit Settings for a Database

Configuring Audit Settings for a Database
This topic describes the procedure to configure audit settings for a database.

Before you begin this task:

  • You must have the role of WS-AppServer Administrator to perform this task.
  • The method set Audit 1.0 Web Service Interface must be attached to the WS-AppServer service.
  • The Enable Audit check box must be enabled for the WS-AppServer Connector Parameters.

The audit settings help in recording all the database related activities. You can identify specific tables in the database for which the auditing is required. This facility enables you to monitor specific tables and not the entire database.

This feature creates one audit table for each selected table. Apart from all the columns in the base table, the audit table contains the following four additional columns:

Column Name

Description

CordysUser

Contains the credentials of the user who modified the data

Note:
The length of the CordysUser field is restricted to 20 characters. If the length of the user name is greater than 20 characters, the user name is truncated to 20 characters while updating the audit table.

CordysOperationType

Determines the type of data operation:

  • I - Insert
  • U - Update
  • D - Delete

CordysTimestamp

Records the date and time when the data was stored in the database. This is the timestamp of the system where the Audit service is active.

CordysGuid

Contains the unique GUID (identifier) for each insert, update, and delete request

Note:
For an update, only the new record is stored in the audit table. The fields of the table that are not provided in the insert, update or delete request are set to null in the audit table.

  1. On CUSP > My Applications, click (Database Metadata Manager). The Database Metadata Manager window appears, displaying the Metadata explorer and the contents of the configured WS-AppServer service.
  2. Expand the contents of the WS-AppServer service until you view Tables and its contents. All the tables in the database are listed.
  3. Right-click a Table and select Audit Configuration. The Audit Configuration app palette appears to the right of the Metadata explorer.
    The Table Name is displayed. A new field for the audit table, Audit Table Name is also created and displayed on the palette window containing a default name <original tablename>_Audit. The columns of the database table are presented in a tabular format with a check box against each column.

    Note:
    When you uninstall Process Platform, the audit fields are not deleted. You must manually remove them from the database.

  4. In the Audit column of the table, select the check box against the column name under Fields, which you want to audit and store in the newly created audit table.

    Note:
    The column that is a primary key for the table is selected by default, and cannot be cleared. It indicates that such a column is audited by default.

  5. Click Save. A confirmation message appears indicating that the configuration is successfully saved.

The audit settings are configured for the database table. The audit table, <original tablename>_Audit is displayed with the icon and added to the list of tables. Click the audit table to view its details on the Audit Configuration tab.

After you complete this task:

  • Restart the related service for the audit settings to be effective.
  • If you need to delete the audit details on the Audit Configuration tab, click Purge Audit Table. The audit details are removed from the audit table.